Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
SafeID (FK)(PK) | The unique identifier for the TENDER RESPOSITORY. | ID_RPSTY_TND | Identity | integer | Safe(AS_SF) |
TenderTypeCode (FK)(PK) | A code which uniquely identifies the type of tender, ie cash, check, credit card, etc. | TY_TND | Code | varchar(20) | Tender(AS_TND) |
OpenMediaUnitQuantity | The opening number of discrete tender media (e.g. currency bills, coins, credit/debit card signed slips, etc.) in the TILL before closing a till settlement period. | QU_OPN_MD_QTY | QuantityInteger | integer | |
CloseBalanceAmount | The closing system maintained tender balance in the SAFE before formalizing the closing of a safe settlement period. | MO_CL_BLNC_AMT | Money | decimal(16,5) | |
CloseMediaUnitQuantity | The closing number of discrete tender media (e.g. currency bills, coins, credit/debit card signed slips, etc.) in the SAFE before the formal closing of a safe settlement period. | QU_CL_MD_UN | QuantityInteger | integer | |
CountedBalanceAmount | The counted tender balance in the SAFE before the fomal closing of a safe settlement period. The counted balance represents the manually counted amount that is compared to the closing balance to determine over/under variance in tender at the end of a till settlement period. | MO_CNT_BLNC_AMT | Money | decimal(16,5) | |
CountedMediaUnitQuantity | The counted number of discrete tender media (e.g. currency bills, coins, credit/debit card signed slips, etc.) in the SAFE before the formal closing of a safe settlement period. | QU_CNT_MD_UN | QuantityInteger | integer | |
OverUnderBalanceAmount | The variance between closing balance amount and counted balance amount before the formal closing of a safe settlement period calculated by subtracting the CountedBalanceAmount from the CloseBalanceAmount A POSITIVE variance means that there is an under variance where the CLOSE balance is higher than the COUNTED balance. A NEGATIVE variance means there is an over variance where the CLOSE balance is less than the COUNTED balance (extra tender) | MO_OVR_UND_BLNC_AMT | Money | decimal(16,5) | |
OverUnderMediaUnitQuantity | The variance between closing media unit quantity and counted media unit quantity before the closing of a safe settlement period calculated by subtracting the CountedMediaUnitQuantity from the CloseMediaUnitQuantity. A POSITIVE variance means that there is an under variance where the CLOSE media unit quantity is higher than the COUNTED media unit quantity A NEGATIVE variance means there is an over variance where the CLOSE media unit quantity is less than the COUNTED media unit quantity (extra tender) | QU_OVR_UND_MD_UN | QuantityInteger | integer | |
PickupFromTillAmount | The running sum of tender amount picked up from tills and received into this SAFE during the safe settlement period before formally closing the period. | MO_PKP_FR_TL_AMT | Money | decimal(16,5) | |
PickupFromTillMediaUnitQuantity | The running sum of tender media unit counts picked up from tills and received into this SAFE during the safe settlement period before formally closing that period. | QU_PKP_FR_TL_MD_UN | QuantityInteger | integer | |
LoanToTillAmount | The running sum of tender amounts loaned to tills from this SAFE during the safe settlement period before formally closing that period. | MO_LON_TO_TL_AMT | Money | decimal(16,5) | |
LoanToTillMediaUnitQuantity | The running sum of tender media unit counts loaned to tills from this SAFE during the safe settlement period before formally closing that period. | QU_LON_TO_TL_MD_UN | QuantityInteger | integer | |
DepositToTenderDespositoryAmount | The running sum of tender amount deposited to an external tender depository (bank) during the safe settlement period prior to closing the period. | MO_DS_TO_TND_DSY_AMT | Money | decimal(16,5) | |
DepositToTenderDepositoryMediaUnitQuantity | The running sum of tender unit quantity deposited to an external tender depository (bank) during the safe settlement period before closing that period. | QU_DS_TO_TND_DSY_MD_UN | QuantityInteger | integer | |
ReceiptFromTenderDepositoryAmount | The running sum of the tender amount received from an external depository (through one or more withdrawals) during a SAFE settlement period prior to the formal end of that period. This represents money withdrawn from a bank to maintain sufficient onhand cash in a store to make change and pay cash to vendors. | MO_RCT_FM_TND_DSY_AMT | Money | decimal(16,5) | |
ReceiptFromTenderDepositoryUnitQuantity | The running total tender media unit count brought IN to a SAFE for a safe settlement period prior to the formal end of that period. | QU_RCPT_FM_TND_DSY_MD_UN | QuantityInteger | integer | |
DisbursementAmount | Running total of tender disbursements made from this SAFE during the safe settlement period prior to the formal end of that period. Note ARTS allows retailers to capture disbursements made at the till level (through the POS) or at the safe level (through the back office system). Retailers may use procedural logic to limit how disbursements are handled. | MO_DSB_AMT | Money | decimal(16,5) | |
DisbursementMediaUnitQuantity | Running total tender disbursement media units made from this SAFE during the safe settlement period prior to the end of that period Note ARTS allows retailers to capture disbursements made at the till level (through the POS) or at the safe level (through the back office system). Retailers may use procedural logic to limit how disbursements are handled. | QU_DSB_MD_UN | QuantityInteger | integer | |
FundsReceiptAmount | Running sum of tender amount received from non retail transaction and non-till pickups during a safe settlement period prior to the closing of that period. This receipt is a misc. inflow of tender that is not related to a retail transaction or a till pick up or bank. | MO_FND_RCT_AMT | Money | decimal(16,5) | |
FundsReceiptMediaUnitQuantity | Running sum of tender media unit quantity received from non retail transaction and non-till pickups during a safe settlement period prior to the formal close of that period. | QU_FND_RCPT_MD_UN | QuantityInteger | integer | |
SafeTransferAmount | The running sum of tender amount transferred between store safes during a safet settlement period prior to the formal closing of that period. This value is one safe's portion of the transfer summary. | MO_SF_TSF_AMT | Money | decimal(16,5) | |
SafeTransferMediaUnitQuantity | The running sum of tender amount transferred between store safes during a safe settlement period prior to the formal closing of that period. This value is one safe's portion of the transfer summary. | QU_SF_TSF_MD_UN | QuantityInteger | integer | |